package com.guangyuan.network.dao.interfaces.sql;

public interface ProductAttrRelSql {
	public String insert = "insert into product_attr_rel(product_id, product_attr_id, gmt_create, gmt_modified, operator, value) values(?, ?, current_timestamp, current_timestamp,?,?)";
	public String delete = "delete from product_attr_rel where id =?";
	public String selectByProductId = "select id, product_id, product_attr_id, gmt_create, gmt_modified, operator, value from product_attr_rel where product_id=?";
	public String update = "update product_attr_rel set value=? where product_id = ? and product_attr_id=?";
	public String deleteAttrByProductId = "delete from product_attr_rel where product_id=?";
}
